package com.supemarket.dao.impl;

import com.supemarket.dao.BaseDao;
import com.supemarket.dao.DelSupemarketDao;

public class DelSupemarketDaoimpl extends BaseDao implements DelSupemarketDao {

	@Override
	public int admindel(int id) {
		String sql ="delete from admin where aid=?";
		return this.executeUpdate(sql,id);
	}

	@Override
	public int commoditiedel(String id) {
		String sql ="delete from commodity where cid=?";
		return this.executeUpdate(sql, id);
	}

	@Override
	public int memberdel(int id) {
		String sql ="delete from member where mid=?";
		return this.executeUpdate(sql, id);
	}

	@Override
	public int purchasedel(int id) {
		String sql ="delete from purchase where pid=?";
		return this.executeUpdate(sql, id);
	}

	@Override
	public int saladel(int id) {
		String sql ="delete from sale where said=?";
		return this.executeUpdate(sql, id);
	}

	@Override
	public int staffdel(int id) {
		String sql ="delete from staff where sid=?";
		return this.executeUpdate(sql, id);
	}

	@Override
	public int supplierdel(int id) {
		String sql ="delete from supplier where suid=?";
		return this.executeUpdate(sql, id);
	}

}
